# -*- coding:utf-8 -*-
"""
Author：Administrator
Date:2023年03月16日
"""
import openpyxl

myBook=openpyxl.load_workbook('录取表.xlsx')
mySheet=myBook['录取表']
myRange=list(mySheet.values)
myNewSheet=myBook.copy_worksheet(mySheet)
myNewSheet.title='新录取表'
while myNewSheet.max_row>3:
	myNewSheet.delete_rows(4)

for myRow in sorted(myRange[3:]):
	myNewSheet.append(myRow)

myBook.save('结果表-录取表.xlsx')